##ENSURE SPREADSHEET IS FILTERED FIRST RUN_DATE (oldest to newest) then by DATETIME (oldest to newest)
# Points to background correct
good_id_mc3_bg<-c(68:75, 925:932, 236:238, 2818:2820, 1093:1095, 265:268, 1122:1123, 1979:1982, 280:283, 2884:2887, 1137:1140, 1994:1997, 665:670, 1522:1527, 145:149, 2721:2725, 1002:1006, 694, 695, 697, 795, 1551, 1552, 1554, 1652, 163, 164, 166, 167, 2739:2741, 2743, 1020:1024, 1877:1879, 1881, 2408, 2409, 2411, 2509 )#350
# 85:91, 899:906, 235:237, 1049:1051, 265:268, 1079:1080, 1893, 1894, 1896, 280:283, 1908:1911, 667:670,672, 149:153, 963:967, 706:708, 1520:1522, 2334:2336, 167, 168, 170, 171, 981:984, 1795, 1796
good_id_mc3_fall<-c(291:293, 295, 297, 299, 302, 305, 307, 933:936, 1061:1065, 351, 352, 354, 356, 358, 360, 362, 429, 366, 368, 370, 2821:2832, 1096:1107, 373:379, 381, 382, 390, 391, 1126:1136, 1983:1993, 392, 394, 395, 397, 399, 401:403, 2889, 2891:2895, 2967, 2970, 2971, 2974, 2975, 1141:1146, 1201, 1203, 1204, 1206, 1207, 1998:2003, 2058, 2060, 2061, 2063, 2064, 671:681, 1641:1651, 627:635, 438, 624, 625, 626,629:635, 2726:2738, 1007:1019, 700, 701, 703, 704, 711,714, 717:724, 638:641, 663, 664, 810:814, 2747,2766:2775, 1028, 1047:1056, 1885, 1904:1913, 1653:1666, 2510:2523, 2538) #350
# 301:309, 907:909, 1014:1016, 320, 351:360, 430, 1052:1063, 373, 375:379, 381:384, 1085:1086, 1898:1904, 385:387, 389:393, 1912:1917, 1950:1954, 674, 676:683, 627:632, 634:636, 972:975, 977:980, 716, 718, 719, 721, 723, 724, 638:643, 988:997, 1797, 1799:1811
## # A tibble: 1 x 1
## n
## <int>
## 1 9
## # A tibble: 16 x 6
## # Groups: date [8]
## date site Cl DOC NO3 PO4
## <date> <chr> <dbl> <dbl> <dbl> <dbl>
## 1 2018-06-26 350 0.0873 NA 0.0697 NA
## 2 2018-06-26 450 0.112 NA 0.213 NA
## 3 2018-06-28 350 0.100 3.67 0.211 NA
## 4 2018-06-28 450 0.0975 4.12 0.005 NA
## 5 2018-06-30 350 0.120 NA 0.100 0.0428
## 6 2018-06-30 450 0.0956 NA 0.0334 0.005
## 7 2018-07-02 350 0.121 3.61 0.005 0.005
## 8 2018-07-02 450 0.168 4.15 0.0691 0.005
## 9 2018-07-17 350 0.775 NA 0.00737 NA
## 10 2018-07-17 450 0.0830 NA 0.0649 NA
## 11 2018-07-19 350 0.239 2.73 0.0551 NA
## 12 2018-07-19 450 0.211 2.64 0.0663 NA
## 13 2018-07-21 350 0.202 NA 0.0488 0.005
## 14 2018-07-21 450 0.676 NA 0.108 0.005
## 15 2018-07-23 350 0.320 3.52 0.0505 0.262
## 16 2018-07-23 450 0.190 3.58 0.214 0.320